<report xmlns="http://developer.cognos.com/schemas/report/12.0/" expressionLocale="en-us" useStyleVersion="10"><!--RSU-SPC-0093 The report specification was upgraded from "http://developer.cognos.com/schemas/report/11.0/" to "http://developer.cognos.com/schemas/report/12.0/" at 2016-3-30. 16:23:32-->
				<modelPath>/content/folder[@name='Packages']/package[@name='Storage and Storage Pool Capacity']/model[@name='model']</modelPath>
				<drillBehavior modelBasedDrillThru="true"/>
				
				<layouts>
					<layout>
						<reportPages>
							
						<pageSet name="Volume" refQuery="Forecast ETL">
			<detailPages><page name="Page1"><style><defaultStyles><defaultStyle refStyle="pg"/></defaultStyles></style>
								<pageBody><style><defaultStyles><defaultStyle refStyle="pb"/></defaultStyles></style>
									<contents>
										
									<HTMLItem>
			<dataSource>
				<staticValue>&lt;style&gt; #headerBack { display: none; } .mainHeader1 { display: none; } .mainViewerHeader3 { display: none; } &lt;/style&gt;</staticValue>
			</dataSource>
		</HTMLItem><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Powered by OnCommand Insight</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:bold;color:white"/></style></textItem></contents><style><CSS value="height:24px;background-color:#6198C5;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>NetApp Internal Volume Forecast</staticValue></dataSource></textItem></contents><style><CSS value="height:36px;padding-left:10px;font-family:Arial;font-size:24px;color:#333333;background-color:#FBFBFB;border-bottom:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Select Volume: </staticValue></dataSource><style><CSS value="color:gray;font-weight:bold"/></style></textItem></contents></tableCell><tableCell><contents/></tableCell><tableCell><contents><selectValue parameter="sVol" refQuery="Volume Prompt" required="false" autoSubmit="true"><useItem refDataItem="Volume"><displayItem refDataItem="Volume"/></useItem><headerText><defaultText>Select Volume</defaultText></headerText></selectValue></contents></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-top:3px;padding-bottom:3px;padding-left:15px;background-color:#F7F7F7"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><list showColumnTitles="hide" refQuery="Forecast ETL" name="List2">
			<listColumns>
				<listColumn>
					<listColumnTitle>
						<contents/>
					</listColumnTitle>
					<listColumnBody>
						<contents><list horizontalPagination="true" name="List1" refQuery="Forecast ETL">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse;border:1pt solid #F7F7F7"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="display:none"/></style><contents><textItem><dataSource><staticValue>Table</staticValue></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lc"/></defaultStyles></style><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Capacity Forecast</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Next 6 Months)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" name="Combination Chart1" refQuery="Forecast ETL">
																				<v2_combinationTypeTooltips/>
																				<v2_commonAxis>
																					<v2_ordinalAxis>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/></style>
																						</v2_axisLabels>
																					</v2_ordinalAxis>
																					<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Date"><chartContents><chartTextItem><dataSource><dataItemValue refDataItem="Date"/></dataSource><style><dataFormat><dateFormat pattern="yyyy-MM"/></dataFormat></style></chartTextItem></chartContents><style><dataFormat><dateFormat pattern="yyyy-MM"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																				<v2_topLeftAxis>
																					<v2_combinationChartTypes>
																						<v2_line lineAreaShape="smooth" lineDisplayType="lineAndMarkers"><v2_linePalette markerBorderColor="white" markerBorders="show" markerSize="8px"><v2_linePaletteEntries><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#8599D3"><v2_solidColor color="#9ABCC3" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#8599D3"><v2_color color="#9ABCC3"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_lineFill defaultColor="#198545"><v2_color color="#89E2F5"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#89E2F5"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#E3AE6C"><v2_solidColor color="#A8E3D7" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#E3AE6C"><v2_color color="#A8E3D7"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px" lineStyle="dot"><v2_lineFill defaultColor="#198545"><v2_color color="#5EEED1"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#5EEED1"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry></v2_linePaletteEntries></v2_linePalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="UsedGB"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode><chartNode><chartNodeMembers><chartNodeMember refDataItem="ProjectedUsedGB"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_line></v2_combinationChartTypes>
																					<v2_axis>
																						<v2_axisRange scale="linear">
																							
																						<v2_automaticRange sameRangeAllInstances="false" includeZeroForAutoScale="true"/></v2_axisRange>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/><dataFormat><numberFormat pattern="###,###' GB'"/></dataFormat></style>
																						</v2_axisLabels>
																						<v2_majorGridlines lineColor="#E1E1E2" lineWeight="0"/>
																					</v2_axis>
																				</v2_topLeftAxis>
																				<style>
																					<defaultStyles>
																						<defaultStyle refStyle="ch"/>
																					</defaultStyles>
																					<CSS value="width:500px;height:300px"/></style>
																				<noDataHandler>
																					<contents>
																						<block>
																							<contents>
																								<textItem>
																									<dataSource>
																										<staticValue>No Data Available</staticValue>
																									</dataSource>
																									<style>
																										<CSS value="padding:10px 18px;"/>
																									</style>
																								</textItem>
																							</contents>
																						</block>
																					</contents>
																				</noDataHandler>
																				<v2_legend>
																					<v2_legendPosition>
																						<v2_legendPreset legendPositionPreset="bottom"/>
																					</v2_legendPosition>
																					<style>
																						<defaultStyles>
																							<defaultStyle refStyle="lg"/>
																						</defaultStyles>
																					<CSS value="font-family:Arial;color:#454545"/></style>
																				</v2_legend>
																				<XMLAttributes><XMLAttribute name="titlesExpanded" output="no" value="true"/></XMLAttributes><masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="Volid"/></masterContext><detailContext><dataItemContext refDataItem="Volid"/></detailContext></masterDetailLink></masterDetailLinks><v2_notes><v2_note refQuery="Forecast ETL"><v2_chartTextItems><v2_chartTextItem><dataSource><staticValue>Used in 6 Months: </staticValue></dataSource></v2_chartTextItem><v2_chartTextItem><dataSource><dataItemValue refDataItem="Used (TB) in 6 Months"/></dataSource><style><dataFormat><numberFormat pattern="###,###' GB'"/></dataFormat></style></v2_chartTextItem></v2_chartTextItems><style><CSS value="font-size:12pt;color:gray;font-weight:bold"/></style><v2_constrainedPosition><v2_verticalPosition><v2_middle offset="0px"/></v2_verticalPosition><v2_horizontalPosition><v2_right offset="0px"/></v2_horizontalPosition><v2_positionAnchor><v2_relativeChart/></v2_positionAnchor></v2_constrainedPosition></v2_note><v2_note refQuery="Forecast ETL"><v2_chartTextItems><v2_chartTextItem><dataSource><staticValue>Growth Rate (CAGR): </staticValue></dataSource></v2_chartTextItem><v2_chartTextItem><dataSource><dataItemValue refDataItem="GrowthRate"/></dataSource><style><dataFormat><numberFormat/></dataFormat></style></v2_chartTextItem></v2_chartTextItems><style><CSS value="font-size:12pt;color:gray;font-weight:bold"/></style><v2_constrainedPosition><v2_verticalPosition><v2_bottom offset="120px"/></v2_verticalPosition><v2_horizontalPosition><v2_right offset="0px"/></v2_horizontalPosition><v2_positionAnchor><v2_relativeChart/></v2_positionAnchor></v2_constrainedPosition></v2_note></v2_notes></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>One Month Trend</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Daily Changes)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" name="Combination Chart2" refQuery="1 Month Trend">
																				<v2_combinationTypeTooltips/>
																				<v2_commonAxis>
																					<v2_ordinalAxis>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/></style>
																						</v2_axisLabels>
																					</v2_ordinalAxis>
																					<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Date"><chartContents><chartTextItem><dataSource><dataItemValue refDataItem="Date"/></dataSource><style><dataFormat><dateFormat pattern="MM-dd"/></dataFormat></style></chartTextItem></chartContents><style><dataFormat><dateFormat pattern="MM-dd"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																				<v2_topLeftAxis>
																					<v2_combinationChartTypes>
																						<v2_line lineAreaShape="smooth" lineDisplayType="lineAndMarkers"><v2_linePalette markerBorderColor="white" markerBorders="show" markerSize="8px"><v2_linePaletteEntries><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#8599D3"><v2_solidColor color="#9ABCC3" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#8599D3"><v2_color color="#9ABCC3"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#E3AE6C"><v2_solidColor color="#A8E3D7" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#E3AE6C"><v2_color color="#A8E3D7"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_lineFill defaultColor="#198545"><v2_color color="#89E2F5"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#89E2F5"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px" lineStyle="dot"><v2_lineFill defaultColor="#198545"><v2_color color="#5EEED1"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#5EEED1"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry></v2_linePaletteEntries></v2_linePalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="UsedGB"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_line></v2_combinationChartTypes>
																					<v2_axis>
																						<v2_axisRange scale="linear">
																							
																						<v2_automaticRange sameRangeAllInstances="false" includeZeroForAutoScale="true"/></v2_axisRange>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/><dataFormat><numberFormat pattern="###,###' GB'"/></dataFormat></style>
																						</v2_axisLabels>
																						<v2_majorGridlines lineColor="#E1E1E2" lineWeight="0"/>
																					</v2_axis>
																				</v2_topLeftAxis>
																				<style>
																					<defaultStyles>
																						<defaultStyle refStyle="ch"/>
																					</defaultStyles>
																					<CSS value="width:500px;height:300px"/></style>
																				<noDataHandler>
																					<contents>
																						<block>
																							<contents>
																								<textItem>
																									<dataSource>
																										<staticValue>No Data Available</staticValue>
																									</dataSource>
																									<style>
																										<CSS value="padding:10px 18px;"/>
																									</style>
																								</textItem>
																							</contents>
																						</block>
																					</contents>
																				</noDataHandler>
																				<v2_legend>
																					<v2_legendPosition>
																						<v2_legendPreset legendPositionPreset="bottom"/>
																					</v2_legendPosition>
																					<style>
																						<defaultStyles>
																							<defaultStyle refStyle="lg"/>
																						</defaultStyles>
																					<CSS value="font-family:Arial;color:#454545"/></style>
																				</v2_legend>
																				<XMLAttributes><XMLAttribute name="titlesExpanded" output="no" value="true"/></XMLAttributes><masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="Volid"/></masterContext><detailContext><dataItemContext refDataItem="Volid"/></detailContext></masterDetailLink></masterDetailLinks></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px;vertical-align:top"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>One Year Trend</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Monthly)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" name="Combination Chart3" refQuery="1 Year Trend">
																				<v2_combinationTypeTooltips/>
																				<v2_commonAxis>
																					<v2_ordinalAxis>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/></style>
																						</v2_axisLabels>
																					</v2_ordinalAxis>
																					<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Date"><chartContents><chartTextItem><dataSource><dataItemValue refDataItem="Date"/></dataSource><style><dataFormat><dateFormat pattern="yyyy-MM"/></dataFormat></style></chartTextItem></chartContents><style><dataFormat><dateFormat pattern="yyyy-MM"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																				<v2_topLeftAxis>
																					<v2_combinationChartTypes>
																						<v2_line lineAreaShape="smooth" lineDisplayType="lineAndMarkers"><v2_linePalette markerBorderColor="white" markerBorders="show" markerSize="8px"><v2_linePaletteEntries><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#8599D3"><v2_solidColor color="#9ABCC3" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#8599D3"><v2_color color="#9ABCC3"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#E3AE6C"><v2_solidColor color="#A8E3D7" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#E3AE6C"><v2_color color="#A8E3D7"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_lineFill defaultColor="#198545"><v2_color color="#89E2F5"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#89E2F5"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px" lineStyle="dot"><v2_lineFill defaultColor="#198545"><v2_color color="#5EEED1"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#5EEED1"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry></v2_linePaletteEntries></v2_linePalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="UsedGB"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_line></v2_combinationChartTypes>
																					<v2_axis>
																						<v2_axisRange scale="linear">
																							
																						<v2_automaticRange sameRangeAllInstances="false" includeZeroForAutoScale="true"/></v2_axisRange>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/><dataFormat><numberFormat pattern="###,###' GB'"/></dataFormat></style>
																						</v2_axisLabels>
																						<v2_majorGridlines lineColor="#E1E1E2" lineWeight="0"/>
																					</v2_axis>
																				</v2_topLeftAxis>
																				<style>
																					<defaultStyles>
																						<defaultStyle refStyle="ch"/>
																					</defaultStyles>
																					<CSS value="width:500px;height:300px"/></style>
																				<noDataHandler>
																					<contents>
																						<block>
																							<contents>
																								<textItem>
																									<dataSource>
																										<staticValue>No Data Available</staticValue>
																									</dataSource>
																									<style>
																										<CSS value="padding:10px 18px;"/>
																									</style>
																								</textItem>
																							</contents>
																						</block>
																					</contents>
																				</noDataHandler>
																				<v2_legend>
																					<v2_legendPosition>
																						<v2_legendPreset legendPositionPreset="bottom"/>
																					</v2_legendPosition>
																					<style>
																						<defaultStyles>
																							<defaultStyle refStyle="lg"/>
																						</defaultStyles>
																					<CSS value="font-family:Arial;color:#454545"/></style>
																				</v2_legend>
																				<XMLAttributes><XMLAttribute name="titlesExpanded" output="no" value="true"/></XMLAttributes><masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="Volid"/></masterContext><detailContext><dataItemContext refDataItem="Volid"/></detailContext></masterDetailLink></masterDetailLinks></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-top:5px;vertical-align:top"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Three Year Trend</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Monthly)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" name="Combination Chart4" refQuery="3 Year Trend">
																				<v2_combinationTypeTooltips/>
																				<v2_commonAxis>
																					<v2_ordinalAxis>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/></style>
																						</v2_axisLabels>
																					</v2_ordinalAxis>
																					<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Date"><chartContents><chartTextItem><dataSource><dataItemValue refDataItem="Date"/></dataSource><style><dataFormat><dateFormat pattern="yyyy-MM"/></dataFormat></style></chartTextItem></chartContents><style><dataFormat><dateFormat pattern="yyyy-MM"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																				<v2_topLeftAxis>
																					<v2_combinationChartTypes>
																						<v2_line lineAreaShape="smooth" lineDisplayType="lineAndMarkers"><v2_linePalette markerBorderColor="white" markerBorders="show" markerSize="8px"><v2_linePaletteEntries><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#8599D3"><v2_solidColor color="#9ABCC3" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#8599D3"><v2_color color="#9ABCC3"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#E3AE6C"><v2_solidColor color="#A8E3D7" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#E3AE6C"><v2_color color="#A8E3D7"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_lineFill defaultColor="#198545"><v2_color color="#89E2F5"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#89E2F5"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px" lineStyle="dot"><v2_lineFill defaultColor="#198545"><v2_color color="#5EEED1"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#5EEED1"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry></v2_linePaletteEntries></v2_linePalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="UsedGB"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_line></v2_combinationChartTypes>
																					<v2_axis>
																						<v2_axisRange scale="linear">
																							
																						<v2_automaticRange sameRangeAllInstances="false" includeZeroForAutoScale="true"/></v2_axisRange>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/><dataFormat><numberFormat pattern="###,###' GB'"/></dataFormat></style>
																						</v2_axisLabels>
																						<v2_majorGridlines lineColor="#E1E1E2" lineWeight="0"/>
																					</v2_axis>
																				</v2_topLeftAxis>
																				<style>
																					<defaultStyles>
																						<defaultStyle refStyle="ch"/>
																					</defaultStyles>
																					<CSS value="width:500px;height:300px"/></style>
																				<noDataHandler>
																					<contents>
																						<block>
																							<contents>
																								<textItem>
																									<dataSource>
																										<staticValue>No Data Available</staticValue>
																									</dataSource>
																									<style>
																										<CSS value="padding:10px 18px;"/>
																									</style>
																								</textItem>
																							</contents>
																						</block>
																					</contents>
																				</noDataHandler>
																				<v2_legend>
																					<v2_legendPosition>
																						<v2_legendPreset legendPositionPreset="bottom"/>
																					</v2_legendPosition>
																					<style>
																						<defaultStyles>
																							<defaultStyle refStyle="lg"/>
																						</defaultStyles>
																					<CSS value="font-family:Arial;color:#454545"/></style>
																				</v2_legend>
																				<XMLAttributes><XMLAttribute name="titlesExpanded" output="no" value="true"/></XMLAttributes><masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="Volid"/></masterContext><detailContext><dataItemContext refDataItem="Volid"/></detailContext></masterDetailLink></masterDetailLinks></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px;vertical-align:top;padding-top:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></listColumnBody></listColumn></listColumns></list></contents>
						<style>
							<defaultStyles>
								<defaultStyle refStyle="sb"/>
							</defaultStyles>
						<CSS value="background-color:#F7F7F7;padding-right:10px;padding-bottom:10px;padding-left:10px"/></style>
					</listColumnBody>
				</listColumn>
			</listColumns>
			
			
			
			<style>
				<CSS value="border-collapse:collapse"/>
				<defaultStyles>
					<defaultStyle refStyle="sc"/>
				</defaultStyles>
			</style>
		<listGroups><listGroup refDataItem="Volume"><listHeader><listRows><listRow><rowCells><rowCell><contents><textItem><dataSource><dataItemLabel refDataItem="Volume"/></dataSource></textItem><textItem><dataSource><staticValue>: </staticValue></dataSource></textItem><textItem><dataSource><dataItemValue refDataItem="Volume"/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="sh"/></defaultStyles><CSS value="font-size:16pt;background-color:white;border-bottom:2.25pt ridge silver"/></style></rowCell></rowCells></listRow></listRows></listHeader><XMLAttributes><XMLAttribute name="RS_SectionedEdge" value="columns" output="no"/></XMLAttributes></listGroup></listGroups><sectionsFrame refFrame="List1" sectionedEdge="columns"/><masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="Volume"/></masterContext><detailContext><dataItemContext refDataItem="Volume"/></detailContext></masterDetailLink></masterDetailLinks></list></contents><style><CSS value="height:10px;background-color:#F7F7F7;padding-right:10px;padding-left:10px;padding-top:10px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents>
								</pageBody>
								
								<pageFooter>
									<contents>
										
									<table>
                                            <tableRows>
                                                <tableRow>
                                                    <tableCells>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <image>
            <dataSource>
                <staticValue>../sanscreen/images/netapp_logo.png</staticValue>
            </dataSource>
        <style><CSS value="width:90px;height:36px"/></style></image></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:left;width:30%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                <textItem><dataSource><staticValue>Page </staticValue></dataSource></textItem><pageNumber/>
                                                            </contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:center;color:#9EA2A2;font-family:Helvetica;font-size:12px;width:40%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <textItem><dataSource><staticValue>OnCommand Insight 7.3.  2014-18 NetApp.</staticValue></dataSource><style><CSS value="font-weight:normal"/></style></textItem></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:right;width:30%;color:#9EA2A2;font-family:Arial;font-size:12px"/>
                                                            </style>
                                                        </tableCell>
                                                    </tableCells>
                                                </tableRow>
                                            </tableRows>
                                            <style>
                                                <defaultStyles>
                                                    <defaultStyle refStyle="tb"/>
                                                </defaultStyles>
                                                <CSS value="border-collapse:collapse;width:100%;height:32px"/>
                                            </style>
                                        </table></contents>
									<style>
										<defaultStyles>
											<defaultStyle refStyle="pf"/>
										</defaultStyles>
										<CSS value="padding-top:10px"/>
									</style>
								</pageFooter>
							</page></detailPages>
		<pageGroups><pageGroup refDataItem="Volume"/></pageGroups></pageSet></reportPages>
					</layout>
				</layouts>
			<XMLAttributes><XMLAttribute name="RS_CreateExtendedDataItems" output="no" value="true"/><XMLAttribute name="listSeparator" output="no" value=","/><XMLAttribute name="RS_modelModificationTime" output="no" value="2017-11-15T20:33:46.811Z"/></XMLAttributes><reportName>2.7 NetApp Internal Volume Forecast - ETL</reportName><classStyles><classStyle name="freezeColumns" label="freezeColumns"/><classStyle name="freezeRows" label="freezeRows"/><classStyle name="freezeCorner" label="freezeCorner"/></classStyles><queries><query name="History">
			<source>
				
			<sqlQuery name="SQL1" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT 
cag.volume as 'Volume',
volhistory.AllocatedGB as 'Allocated GB',
volhistory.UsedGB as 'Used GB',
volhistory.Date as 'Date',
cag.growthrate as 'Growth Rate %'

FROM

(
SELECT 
dwh_capacity.internal_volume_dimension.id as 'hvolid',
dwh_capacity.internal_volume_capacity_fact.AllocatedCapacityMB/1024 as 'AllocatedGB',
dwh_capacity.internal_volume_capacity_fact.usedCapacityMB/1024 as 'UsedGB',
DATE_FORMAT(dwh_capacity.date_dimension.fulldate, '%Y-%m-%d') as 'Date'

FROM dwh_capacity.internal_volume_capacity_fact
JOIN dwh_capacity.internal_volume_dimension
ON dwh_capacity.internal_volume_dimension.tk=dwh_capacity.internal_volume_capacity_fact.internalvolumetk
JOIN dwh_capacity.date_dimension
ON dwh_capacity.date_dimension.tk=dwh_capacity.internal_volume_capacity_fact.datetk
AND dwh_capacity.date_dimension.repmonth=1
GROUP BY dwh_capacity.internal_volume_dimension.id, DATE_FORMAT(dwh_capacity.date_dimension.fulldate, '%Y-%m-%d')

) volhistory

JOIN

(
SELECT
cagr.volume as 'Volume',
cagr.volid as 'Volid',
cagr.CAGR as 'GrowthRate'

FROM
(
SELECT
IFNULL(end.volume,begin.volume) as 'Volume',
IFNULL(end.volid,begin.volid) as 'Volid',
begin.BeginUsed,
begin.date as 'BeginDate',
end.EndUsed,
end.date as 'EndDate',

TIMESTAMPDIFF(MONTH,begin.date,end.date) as 'DataPoints',

ROUND(power(end.EndUsed / begin.BeginUsed, 1/TIMESTAMPDIFF(MONTH,begin.date,end.date))-1,2) as 'CAGR'

FROM
(

SELECT DISTINCT 
dwh_capacity.internal_volume_dimension.name as 'Volume',
dwh_capacity.internal_volume_dimension.id as 'volid',
(dwh_capacity.internal_volume_capacity_fact.usedCapacityMB)/1024 as 'EndUsed',
DATE_FORMAT(dwh_capacity.date_dimension.fulldate, '%Y-%m-%d') as 'Date'

FROM dwh_capacity.internal_volume_capacity_fact
JOIN dwh_capacity.internal_volume_dimension
ON dwh_capacity.internal_volume_dimension.tk=dwh_capacity.internal_volume_capacity_fact.internalvolumetk
JOIN dwh_capacity.date_dimension
ON dwh_capacity.date_dimension.tk=dwh_capacity.internal_volume_capacity_fact.datetk
AND dwh_capacity.date_dimension.latest=1

GROUP BY dwh_capacity.internal_volume_dimension.tk

) end

LEFT JOIN

(

SELECT DISTINCT 
dwh_capacity.internal_volume_dimension.name as 'Volume',
dwh_capacity.internal_volume_dimension.id as 'volid',
(dwh_capacity.internal_volume_capacity_fact.usedCapacityMB)/1024 as 'BeginUsed',
DATE_FORMAT(dwh_capacity.date_dimension.fulldate, '%Y-%m-%d') as 'Date'

FROM dwh_capacity.internal_volume_capacity_fact
JOIN dwh_capacity.internal_volume_dimension
ON dwh_capacity.internal_volume_dimension.tk=dwh_capacity.internal_volume_capacity_fact.internalvolumetk
JOIN dwh_capacity.date_dimension
ON dwh_capacity.date_dimension.tk=dwh_capacity.internal_volume_capacity_fact.datetk

WHERE DATE_FORMAT(dwh_capacity.date_dimension.fullDate, '%Y-%m-%d') &gt;= (SELECT DATE_FORMAT(MIN(dwh_capacity.date_dimension.fullDate),'%Y-%m-%d')
FROM dwh_capacity.date_dimension)

GROUP BY dwh_capacity.internal_volume_dimension.id

) begin ON begin.volid=end.volid

) cagr

HAVING cagr.CAGR is not null ) cag ON cag.volid=volhistory.hvolid


</sqlText>
		<mdProjectedItems><mdProjectedItem name="Volume"/><mdProjectedItem name="Allocated GB"/><mdProjectedItem name="Used GB"/><mdProjectedItem name="Date"/><mdProjectedItem name="Growth Rate %"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Volume"><expression>[SQL1].[Volume]</expression></dataItem><dataItem name="Allocated GB"><expression>[SQL1].[Allocated GB]</expression></dataItem><dataItem name="Used GB"><expression>[SQL1].[Used GB]</expression></dataItem><dataItem name="Date"><expression>[SQL1].[Date]</expression></dataItem><dataItem name="Growth Rate %"><expression>[SQL1].[Growth Rate %]</expression></dataItem></selection>
		</query><query name="Growth Rate">
			<source>
				
			<sqlQuery name="SQL2" dataSource="dwh_capacity" type="passThrough">
			<sqlText>
SELECT 
cag.volume as 'Volume',
cag.volid as 'Volid',
volhistory.AllocatedGB as 'Allocated GB',
volhistory.UsedGB as 'Used GB',
volhistory.Date as 'Date',
cag.growthrate as 'Growth Rate %'

FROM

(
SELECT 
dwh_capacity.internal_volume_dimension.id as 'hvolid',
dwh_capacity.internal_volume_capacity_fact.AllocatedCapacityMB/1024 as 'AllocatedGB',
dwh_capacity.internal_volume_capacity_fact.usedCapacityMB/1024 as 'UsedGB',
DATE_FORMAT(dwh_capacity.date_dimension.fulldate, '%Y-%m-%d') as 'Date'

FROM dwh_capacity.internal_volume_capacity_fact
JOIN dwh_capacity.internal_volume_dimension
ON dwh_capacity.internal_volume_dimension.tk=dwh_capacity.internal_volume_capacity_fact.internalvolumetk
JOIN dwh_capacity.date_dimension
ON dwh_capacity.date_dimension.tk=dwh_capacity.internal_volume_capacity_fact.datetk
AND dwh_capacity.date_dimension.latest=1
GROUP BY dwh_capacity.internal_volume_dimension.id

) volhistory

JOIN

(
SELECT
cagr.volume as 'Volume',
cagr.volid as 'Volid',
cagr.CAGR as 'GrowthRate'

FROM
(
SELECT
IFNULL(end.volume,begin.volume) as 'Volume',
IFNULL(end.volid,begin.volid) as 'Volid',
begin.BeginUsed,
begin.date as 'BeginDate',
end.EndUsed,
end.date as 'EndDate',

TIMESTAMPDIFF(MONTH,begin.date,end.date) as 'DataPoints',

ROUND(power(end.EndUsed / begin.BeginUsed, 1/TIMESTAMPDIFF(MONTH,begin.date,end.date))-1,2) as 'CAGR'

FROM
(

SELECT DISTINCT 
dwh_capacity.internal_volume_dimension.name as 'Volume',
dwh_capacity.internal_volume_dimension.id as 'volid',
(dwh_capacity.internal_volume_capacity_fact.usedCapacityMB)/1024 as 'EndUsed',
DATE_FORMAT(dwh_capacity.date_dimension.fulldate, '%Y-%m-%d') as 'Date'

FROM dwh_capacity.internal_volume_capacity_fact
JOIN dwh_capacity.internal_volume_dimension
ON dwh_capacity.internal_volume_dimension.tk=dwh_capacity.internal_volume_capacity_fact.internalvolumetk
JOIN dwh_capacity.date_dimension
ON dwh_capacity.date_dimension.tk=dwh_capacity.internal_volume_capacity_fact.datetk
AND dwh_capacity.date_dimension.latest=1

GROUP BY dwh_capacity.internal_volume_dimension.tk

) end

LEFT JOIN

(

SELECT DISTINCT 
dwh_capacity.internal_volume_dimension.name as 'Volume',
dwh_capacity.internal_volume_dimension.id as 'volid',
(dwh_capacity.internal_volume_capacity_fact.usedCapacityMB)/1024 as 'BeginUsed',
DATE_FORMAT(dwh_capacity.date_dimension.fulldate, '%Y-%m-%d') as 'Date'

FROM dwh_capacity.internal_volume_capacity_fact
JOIN dwh_capacity.internal_volume_dimension
ON dwh_capacity.internal_volume_dimension.tk=dwh_capacity.internal_volume_capacity_fact.internalvolumetk
JOIN dwh_capacity.date_dimension
ON dwh_capacity.date_dimension.tk=dwh_capacity.internal_volume_capacity_fact.datetk

WHERE DATE_FORMAT(dwh_capacity.date_dimension.fullDate, '%Y-%m-%d') &gt;= (SELECT DATE_FORMAT(MIN(dwh_capacity.date_dimension.fullDate),'%Y-%m-%d')
FROM dwh_capacity.date_dimension)

GROUP BY dwh_capacity.internal_volume_dimension.id

) begin ON begin.volid=end.volid

) cagr

HAVING cagr.CAGR is not null ) cag ON cag.volid=volhistory.hvolid


</sqlText>
		<mdProjectedItems><mdProjectedItem name="Volume"/><mdProjectedItem name="Volid"/><mdProjectedItem name="Allocated GB"/><mdProjectedItem name="Used GB"/><mdProjectedItem name="Date"/><mdProjectedItem name="Growth Rate %"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Volid"><expression>[SQL2].[Volid]</expression></dataItem><dataItem name="Volume"><expression>[SQL2].[Volume]</expression></dataItem><dataItem name="Allocated GB"><expression>[SQL2].[Allocated GB]</expression></dataItem><dataItem name="Used GB"><expression>[SQL2].[Used GB]</expression></dataItem><dataItem name="Date"><expression>[SQL2].[Date]</expression></dataItem><dataItem name="Growth Rate %"><expression>[SQL2].[Growth Rate %]</expression></dataItem></selection>
		</query><query name="Forecast">
			<source>
				
			<sqlQuery name="SQL3" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT
dwh_capacity.internal_volume_dimension.name as 'Volume',
dwh_capacity.internal_volume_dimension.id as 'Volid',
dwh_capacity.internal_volume_capacity_fact.allocatedCapacityMB/1024 as 'AllocatedGB',
dwh_capacity.internal_volume_capacity_fact.usedCapacityMB/1024 as 'UsedGB',
dwh_capacity.date_dimension.fulldate as 'Date',
null as 'GrowthRate',
null as 'ProjectedAllocatedGB',
null as 'ProjectedUsedGB'

FROM dwh_capacity.internal_volume_capacity_fact
JOIN dwh_capacity.internal_volume_dimension
ON   dwh_capacity.internal_volume_dimension.tk=dwh_capacity.internal_volume_capacity_fact.internalvolumetk

JOIN dwh_capacity.date_dimension
ON   dwh_capacity.date_dimension.tk=dwh_capacity.internal_volume_capacity_fact.datetk
AND  dwh_capacity.date_dimension.repmonthorlatest=1
 
WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
FROM dwh_capacity.date_dimension JOIN dwh_capacity.internal_volume_capacity_fact 
ON dwh_capacity.internal_volume_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 12 MONTH



GROUP BY dwh_capacity.internal_volume_dimension.id, dwh_capacity.date_dimension.fulldate

UNION

SELECT 
cag.volume as 'Volume',
cag.volid as 'Volid',
null as 'AllocatedGB',
null as 'UsedGB',
volhistory.date as 'Date',
cag.growthrate as 'GrowthRate',
ROUND(volhistory.AllocatedGB,2) as 'ProjectedAllocatedGB',
ROUND(volhistory.usedGB,2) as 'ProjectedUsedGB'


FROM

(
SELECT 
dwh_capacity.internal_volume_dimension.id as 'hvolid',
dwh_capacity.internal_volume_capacity_fact.AllocatedCapacityMB/1024 as 'AllocatedGB',
dwh_capacity.internal_volume_capacity_fact.usedCapacityMB/1024 as 'UsedGB',
dwh_capacity.date_dimension.fulldate as 'Date'

FROM dwh_capacity.internal_volume_capacity_fact
JOIN dwh_capacity.internal_volume_dimension
ON dwh_capacity.internal_volume_dimension.tk=dwh_capacity.internal_volume_capacity_fact.internalvolumetk
JOIN dwh_capacity.date_dimension
ON dwh_capacity.date_dimension.tk=dwh_capacity.internal_volume_capacity_fact.datetk
AND dwh_capacity.date_dimension.latest=1
GROUP BY dwh_capacity.internal_volume_dimension.id

) volhistory

JOIN

(
SELECT
cagr.volume as 'Volume',
cagr.volid as 'Volid',
cagr.CAGR as 'GrowthRate'

FROM
(
SELECT
IFNULL(end.volume,begin.volume) as 'Volume',
IFNULL(end.volid,begin.volid) as 'Volid',
begin.BeginUsed,
begin.date as 'BeginDate',
end.EndUsed,
end.date as 'EndDate',

TIMESTAMPDIFF(MONTH,begin.date,end.date) as 'DataPoints',

ROUND(power(end.EndUsed / begin.BeginUsed, 1/TIMESTAMPDIFF(MONTH,begin.date,end.date))-1,2) as 'CAGR'

FROM
(

SELECT DISTINCT 
dwh_capacity.internal_volume_dimension.name as 'Volume',
dwh_capacity.internal_volume_dimension.id as 'volid',
(dwh_capacity.internal_volume_capacity_fact.usedCapacityMB)/1024 as 'EndUsed',
DATE_FORMAT(dwh_capacity.date_dimension.fulldate, '%Y-%m-%d') as 'Date'

FROM dwh_capacity.internal_volume_capacity_fact
JOIN dwh_capacity.internal_volume_dimension
ON dwh_capacity.internal_volume_dimension.tk=dwh_capacity.internal_volume_capacity_fact.internalvolumetk
JOIN dwh_capacity.date_dimension
ON dwh_capacity.date_dimension.tk=dwh_capacity.internal_volume_capacity_fact.datetk
AND dwh_capacity.date_dimension.latest=1
AND dwh_capacity.internal_volume_capacity_fact.usedCapacityMB&gt;0

GROUP BY dwh_capacity.internal_volume_dimension.tk

) end

LEFT JOIN

(

SELECT
begincap.Volume,
begincap.volid,
begincap.BeginUsed,
begincap.Date

FROM(
SELECT DISTINCT 
dwh_capacity.internal_volume_dimension.name as 'Volume',
dwh_capacity.internal_volume_dimension.id as 'volid',
(dwh_capacity.internal_volume_capacity_fact.usedCapacityMB)/1024 as 'BeginUsed',
DATE_FORMAT(dwh_capacity.date_dimension.fulldate, '%Y-%m-%d') as 'Date'

FROM dwh_capacity.internal_volume_capacity_fact
JOIN dwh_capacity.internal_volume_dimension
ON dwh_capacity.internal_volume_dimension.tk=dwh_capacity.internal_volume_capacity_fact.internalvolumetk
JOIN dwh_capacity.date_dimension
ON dwh_capacity.date_dimension.tk=dwh_capacity.internal_volume_capacity_fact.datetk

WHERE DATE_FORMAT(dwh_capacity.date_dimension.fullDate, '%Y-%m-%d') &gt;= (SELECT DATE_FORMAT(MIN(dwh_capacity.date_dimension.fullDate),'%Y-%m-%d')
FROM dwh_capacity.date_dimension)

GROUP BY dwh_capacity.internal_volume_dimension.id) begincap
HAVING begincap.BeginUsed &gt; 0 

) begin ON begin.volid=end.volid

HAVING begin.BeginUsed is not null AND DataPoints &gt; 0

) cagr

 ) cag ON cag.volid=volhistory.hvolid 


UNION

/* Get First Month Growth Data */

SELECT 
cag.volume as 'Volume',
cag.volid as 'Volid',
null as 'AllocatedGB',
null as 'UsedGB',
DATE_ADD(volhistory.date, INTERVAL 1 MONTH) as 'Date',
cag.growthrate as 'GrowthRate',
ROUND(volhistory.AllocatedGB,2) as 'ProjectedAllocatedGB',
ROUND((volhistory.usedGB*cag.growthrate)+volhistory.usedGB,2) as 'ProjectedUsedGB'


FROM

(
SELECT 
dwh_capacity.internal_volume_dimension.id as 'hvolid',
dwh_capacity.internal_volume_capacity_fact.AllocatedCapacityMB/1024 as 'AllocatedGB',
dwh_capacity.internal_volume_capacity_fact.usedCapacityMB/1024 as 'UsedGB',
dwh_capacity.date_dimension.fulldate as 'Date'

FROM dwh_capacity.internal_volume_capacity_fact
JOIN dwh_capacity.internal_volume_dimension
ON dwh_capacity.internal_volume_dimension.tk=dwh_capacity.internal_volume_capacity_fact.internalvolumetk
JOIN dwh_capacity.date_dimension
ON dwh_capacity.date_dimension.tk=dwh_capacity.internal_volume_capacity_fact.datetk
AND dwh_capacity.date_dimension.latest=1
GROUP BY dwh_capacity.internal_volume_dimension.id

) volhistory

JOIN

(
SELECT
cagr.volume as 'Volume',
cagr.volid as 'Volid',
cagr.CAGR as 'GrowthRate'

FROM
(
SELECT
IFNULL(end.volume,begin.volume) as 'Volume',
IFNULL(end.volid,begin.volid) as 'Volid',
begin.BeginUsed,
begin.date as 'BeginDate',
end.EndUsed,
end.date as 'EndDate',

TIMESTAMPDIFF(MONTH,begin.date,end.date) as 'DataPoints',

ROUND(power(end.EndUsed / begin.BeginUsed, 1/TIMESTAMPDIFF(MONTH,begin.date,end.date))-1,2) as 'CAGR'

FROM
(

SELECT DISTINCT 
dwh_capacity.internal_volume_dimension.name as 'Volume',
dwh_capacity.internal_volume_dimension.id as 'volid',
(dwh_capacity.internal_volume_capacity_fact.usedCapacityMB)/1024 as 'EndUsed',
DATE_FORMAT(dwh_capacity.date_dimension.fulldate, '%Y-%m-%d') as 'Date'

FROM dwh_capacity.internal_volume_capacity_fact
JOIN dwh_capacity.internal_volume_dimension
ON dwh_capacity.internal_volume_dimension.tk=dwh_capacity.internal_volume_capacity_fact.internalvolumetk
JOIN dwh_capacity.date_dimension
ON dwh_capacity.date_dimension.tk=dwh_capacity.internal_volume_capacity_fact.datetk
AND dwh_capacity.date_dimension.latest=1
AND dwh_capacity.internal_volume_capacity_fact.usedCapacityMB&gt;0

GROUP BY dwh_capacity.internal_volume_dimension.tk

) end

LEFT JOIN

(

SELECT
begincap.Volume,
begincap.volid,
begincap.BeginUsed,
begincap.Date

FROM(
SELECT DISTINCT 
dwh_capacity.internal_volume_dimension.name as 'Volume',
dwh_capacity.internal_volume_dimension.id as 'volid',
(dwh_capacity.internal_volume_capacity_fact.usedCapacityMB)/1024 as 'BeginUsed',
DATE_FORMAT(dwh_capacity.date_dimension.fulldate, '%Y-%m-%d') as 'Date'

FROM dwh_capacity.internal_volume_capacity_fact
JOIN dwh_capacity.internal_volume_dimension
ON dwh_capacity.internal_volume_dimension.tk=dwh_capacity.internal_volume_capacity_fact.internalvolumetk
JOIN dwh_capacity.date_dimension
ON dwh_capacity.date_dimension.tk=dwh_capacity.internal_volume_capacity_fact.datetk

WHERE DATE_FORMAT(dwh_capacity.date_dimension.fullDate, '%Y-%m-%d') &gt;= (SELECT DATE_FORMAT(MIN(dwh_capacity.date_dimension.fullDate),'%Y-%m-%d')
FROM dwh_capacity.date_dimension)

GROUP BY dwh_capacity.internal_volume_dimension.id) begincap
HAVING begincap.BeginUsed &gt; 0 

) begin ON begin.volid=end.volid

HAVING begin.BeginUsed is not null AND DataPoints &gt; 0

) cagr

 ) cag ON cag.volid=volhistory.hvolid 



/* Get 2nd Month Growth Data */

UNION

SELECT 
cag.volume as 'Volume',
cag.volid as 'Volid',
null as 'AllocatedGB',
null as 'UsedGB',
DATE_ADD(volhistory.date, INTERVAL 3 MONTH) as 'Date',
cag.growthrate as 'GrowthRate',
ROUND(volhistory.AllocatedGB,2) as 'ProjectedAllocatedGB',
ROUND((((volhistory.usedGB*cag.growthrate)+volhistory.usedGB)*cag.growthrate)+(volhistory.usedGB*cag.growthrate)+volhistory.usedGB,2)
 as 'ProjectedUsedGB'


FROM

(
SELECT 
dwh_capacity.internal_volume_dimension.id as 'hvolid',
dwh_capacity.internal_volume_capacity_fact.AllocatedCapacityMB/1024 as 'AllocatedGB',
dwh_capacity.internal_volume_capacity_fact.usedCapacityMB/1024 as 'UsedGB',
dwh_capacity.date_dimension.fulldate as 'Date'

FROM dwh_capacity.internal_volume_capacity_fact
JOIN dwh_capacity.internal_volume_dimension
ON dwh_capacity.internal_volume_dimension.tk=dwh_capacity.internal_volume_capacity_fact.internalvolumetk
JOIN dwh_capacity.date_dimension
ON dwh_capacity.date_dimension.tk=dwh_capacity.internal_volume_capacity_fact.datetk
AND dwh_capacity.date_dimension.latest=1
GROUP BY dwh_capacity.internal_volume_dimension.id

) volhistory

JOIN

(
SELECT
cagr.volume as 'Volume',
cagr.volid as 'Volid',
cagr.CAGR as 'GrowthRate'

FROM
(
SELECT
IFNULL(end.volume,begin.volume) as 'Volume',
IFNULL(end.volid,begin.volid) as 'Volid',
begin.BeginUsed,
begin.date as 'BeginDate',
end.EndUsed,
end.date as 'EndDate',

TIMESTAMPDIFF(MONTH,begin.date,end.date) as 'DataPoints',

ROUND(power(end.EndUsed / begin.BeginUsed, 1/TIMESTAMPDIFF(MONTH,begin.date,end.date))-1,2) as 'CAGR'

FROM
(

SELECT DISTINCT 
dwh_capacity.internal_volume_dimension.name as 'Volume',
dwh_capacity.internal_volume_dimension.id as 'volid',
(dwh_capacity.internal_volume_capacity_fact.usedCapacityMB)/1024 as 'EndUsed',
DATE_FORMAT(dwh_capacity.date_dimension.fulldate, '%Y-%m-%d') as 'Date'

FROM dwh_capacity.internal_volume_capacity_fact
JOIN dwh_capacity.internal_volume_dimension
ON dwh_capacity.internal_volume_dimension.tk=dwh_capacity.internal_volume_capacity_fact.internalvolumetk
JOIN dwh_capacity.date_dimension
ON dwh_capacity.date_dimension.tk=dwh_capacity.internal_volume_capacity_fact.datetk
AND dwh_capacity.date_dimension.latest=1
AND dwh_capacity.internal_volume_capacity_fact.usedCapacityMB&gt;0

GROUP BY dwh_capacity.internal_volume_dimension.tk

) end

LEFT JOIN

(

SELECT
begincap.Volume,
begincap.volid,
begincap.BeginUsed,
begincap.Date

FROM(
SELECT DISTINCT 
dwh_capacity.internal_volume_dimension.name as 'Volume',
dwh_capacity.internal_volume_dimension.id as 'volid',
(dwh_capacity.internal_volume_capacity_fact.usedCapacityMB)/1024 as 'BeginUsed',
DATE_FORMAT(dwh_capacity.date_dimension.fulldate, '%Y-%m-%d') as 'Date'

FROM dwh_capacity.internal_volume_capacity_fact
JOIN dwh_capacity.internal_volume_dimension
ON dwh_capacity.internal_volume_dimension.tk=dwh_capacity.internal_volume_capacity_fact.internalvolumetk
JOIN dwh_capacity.date_dimension
ON dwh_capacity.date_dimension.tk=dwh_capacity.internal_volume_capacity_fact.datetk

WHERE DATE_FORMAT(dwh_capacity.date_dimension.fullDate, '%Y-%m-%d') &gt;= (SELECT DATE_FORMAT(MIN(dwh_capacity.date_dimension.fullDate),'%Y-%m-%d')
FROM dwh_capacity.date_dimension)

GROUP BY dwh_capacity.internal_volume_dimension.id) begincap
HAVING begincap.BeginUsed &gt; 0 

) begin ON begin.volid=end.volid

HAVING begin.BeginUsed is not null AND DataPoints &gt; 0

) cagr

 ) cag ON cag.volid=volhistory.hvolid 


/* Get 3rd Month Future Data */

UNION

SELECT 
cag.volume as 'Volume',
cag.volid as 'Volid',
null as 'AllocatedGB',
null as 'UsedGB',
DATE_ADD(volhistory.date, INTERVAL 2 MONTH) as 'Date',
cag.growthrate as 'GrowthRate',
ROUND(volhistory.AllocatedGB,2) as 'ProjectedAllocatedGB',
ROUND((((((volhistory.usedGB*cag.growthrate)+volhistory.usedGB)*cag.growthrate)+(volhistory.usedGB*cag.growthrate)+volhistory.usedGB)*cag.growthrate)+(((volhistory.usedGB*cag.growthrate)+volhistory.usedGB)*cag.growthrate)+(volhistory.usedGB*cag.growthrate)+volhistory.usedGB,2)
 as 'ProjectedUsedGB'


FROM

(
SELECT 
dwh_capacity.internal_volume_dimension.id as 'hvolid',
dwh_capacity.internal_volume_capacity_fact.AllocatedCapacityMB/1024 as 'AllocatedGB',
dwh_capacity.internal_volume_capacity_fact.usedCapacityMB/1024 as 'UsedGB',
dwh_capacity.date_dimension.fulldate as 'Date'

FROM dwh_capacity.internal_volume_capacity_fact
JOIN dwh_capacity.internal_volume_dimension
ON dwh_capacity.internal_volume_dimension.tk=dwh_capacity.internal_volume_capacity_fact.internalvolumetk
JOIN dwh_capacity.date_dimension
ON dwh_capacity.date_dimension.tk=dwh_capacity.internal_volume_capacity_fact.datetk
AND dwh_capacity.date_dimension.latest=1
GROUP BY dwh_capacity.internal_volume_dimension.id

) volhistory

JOIN

(
SELECT
cagr.volume as 'Volume',
cagr.volid as 'Volid',
cagr.CAGR as 'GrowthRate'

FROM
(
SELECT
IFNULL(end.volume,begin.volume) as 'Volume',
IFNULL(end.volid,begin.volid) as 'Volid',
begin.BeginUsed,
begin.date as 'BeginDate',
end.EndUsed,
end.date as 'EndDate',

TIMESTAMPDIFF(MONTH,begin.date,end.date) as 'DataPoints',

ROUND(power(end.EndUsed / begin.BeginUsed, 1/TIMESTAMPDIFF(MONTH,begin.date,end.date))-1,2) as 'CAGR'

FROM
(

SELECT DISTINCT 
dwh_capacity.internal_volume_dimension.name as 'Volume',
dwh_capacity.internal_volume_dimension.id as 'volid',
(dwh_capacity.internal_volume_capacity_fact.usedCapacityMB)/1024 as 'EndUsed',
DATE_FORMAT(dwh_capacity.date_dimension.fulldate, '%Y-%m-%d') as 'Date'

FROM dwh_capacity.internal_volume_capacity_fact
JOIN dwh_capacity.internal_volume_dimension
ON dwh_capacity.internal_volume_dimension.tk=dwh_capacity.internal_volume_capacity_fact.internalvolumetk
JOIN dwh_capacity.date_dimension
ON dwh_capacity.date_dimension.tk=dwh_capacity.internal_volume_capacity_fact.datetk
AND dwh_capacity.date_dimension.latest=1
AND dwh_capacity.internal_volume_capacity_fact.usedCapacityMB&gt;0

GROUP BY dwh_capacity.internal_volume_dimension.tk

) end

LEFT JOIN

(

SELECT
begincap.Volume,
begincap.volid,
begincap.BeginUsed,
begincap.Date

FROM(
SELECT DISTINCT 
dwh_capacity.internal_volume_dimension.name as 'Volume',
dwh_capacity.internal_volume_dimension.id as 'volid',
(dwh_capacity.internal_volume_capacity_fact.usedCapacityMB)/1024 as 'BeginUsed',
DATE_FORMAT(dwh_capacity.date_dimension.fulldate, '%Y-%m-%d') as 'Date'

FROM dwh_capacity.internal_volume_capacity_fact
JOIN dwh_capacity.internal_volume_dimension
ON dwh_capacity.internal_volume_dimension.tk=dwh_capacity.internal_volume_capacity_fact.internalvolumetk
JOIN dwh_capacity.date_dimension
ON dwh_capacity.date_dimension.tk=dwh_capacity.internal_volume_capacity_fact.datetk

WHERE DATE_FORMAT(dwh_capacity.date_dimension.fullDate, '%Y-%m-%d') &gt;= (SELECT DATE_FORMAT(MIN(dwh_capacity.date_dimension.fullDate),'%Y-%m-%d')
FROM dwh_capacity.date_dimension)

GROUP BY dwh_capacity.internal_volume_dimension.id) begincap
HAVING begincap.BeginUsed &gt; 0 

) begin ON begin.volid=end.volid

HAVING begin.BeginUsed is not null AND DataPoints &gt; 0

) cagr

 ) cag ON cag.volid=volhistory.hvolid 


/* Get 4th Month Future Data */

UNION

SELECT 
cag.volume as 'Volume',
cag.volid as 'Volid',
null as 'AllocatedGB',
null as 'UsedGB',
DATE_ADD(volhistory.date, INTERVAL 4 MONTH) as 'Date',
cag.growthrate as 'GrowthRate',
ROUND(volhistory.AllocatedGB,2) as 'ProjectedAllocatedGB',
ROUND(((
(((((volhistory.usedGB*cag.growthrate)+volhistory.usedGB)*cag.growthrate)+(volhistory.usedGB*cag.growthrate)+volhistory.usedGB)*cag.growthrate)+(((volhistory.usedGB*cag.growthrate)+volhistory.usedGB)*cag.growthrate)+(volhistory.usedGB*cag.growthrate)+volhistory.usedGB)*cag.growthrate)+(((((volhistory.usedGB*cag.growthrate)+volhistory.usedGB)*cag.growthrate)+(volhistory.usedGB*cag.growthrate)+volhistory.usedGB)*cag.growthrate)+(((volhistory.usedGB*cag.growthrate)+volhistory.usedGB)*cag.growthrate)+(volhistory.usedGB*cag.growthrate)+volhistory.usedGB,2)
as 'ProjectedUsedGB'


FROM

(
SELECT 
dwh_capacity.internal_volume_dimension.id as 'hvolid',
dwh_capacity.internal_volume_capacity_fact.AllocatedCapacityMB/1024 as 'AllocatedGB',
dwh_capacity.internal_volume_capacity_fact.usedCapacityMB/1024 as 'UsedGB',
dwh_capacity.date_dimension.fulldate as 'Date'

FROM dwh_capacity.internal_volume_capacity_fact
JOIN dwh_capacity.internal_volume_dimension
ON dwh_capacity.internal_volume_dimension.tk=dwh_capacity.internal_volume_capacity_fact.internalvolumetk
JOIN dwh_capacity.date_dimension
ON dwh_capacity.date_dimension.tk=dwh_capacity.internal_volume_capacity_fact.datetk
AND dwh_capacity.date_dimension.latest=1
GROUP BY dwh_capacity.internal_volume_dimension.id

) volhistory

JOIN

(
SELECT
cagr.volume as 'Volume',
cagr.volid as 'Volid',
cagr.CAGR as 'GrowthRate'

FROM
(
SELECT
IFNULL(end.volume,begin.volume) as 'Volume',
IFNULL(end.volid,begin.volid) as 'Volid',
begin.BeginUsed,
begin.date as 'BeginDate',
end.EndUsed,
end.date as 'EndDate',

TIMESTAMPDIFF(MONTH,begin.date,end.date) as 'DataPoints',

ROUND(power(end.EndUsed / begin.BeginUsed, 1/TIMESTAMPDIFF(MONTH,begin.date,end.date))-1,2) as 'CAGR'

FROM
(

SELECT DISTINCT 
dwh_capacity.internal_volume_dimension.name as 'Volume',
dwh_capacity.internal_volume_dimension.id as 'volid',
(dwh_capacity.internal_volume_capacity_fact.usedCapacityMB)/1024 as 'EndUsed',
DATE_FORMAT(dwh_capacity.date_dimension.fulldate, '%Y-%m-%d') as 'Date'

FROM dwh_capacity.internal_volume_capacity_fact
JOIN dwh_capacity.internal_volume_dimension
ON dwh_capacity.internal_volume_dimension.tk=dwh_capacity.internal_volume_capacity_fact.internalvolumetk
JOIN dwh_capacity.date_dimension
ON dwh_capacity.date_dimension.tk=dwh_capacity.internal_volume_capacity_fact.datetk
AND dwh_capacity.date_dimension.latest=1
AND dwh_capacity.internal_volume_capacity_fact.usedCapacityMB&gt;0

GROUP BY dwh_capacity.internal_volume_dimension.tk

) end

LEFT JOIN

(

SELECT
begincap.Volume,
begincap.volid,
begincap.BeginUsed,
begincap.Date

FROM(
SELECT DISTINCT 
dwh_capacity.internal_volume_dimension.name as 'Volume',
dwh_capacity.internal_volume_dimension.id as 'volid',
(dwh_capacity.internal_volume_capacity_fact.usedCapacityMB)/1024 as 'BeginUsed',
DATE_FORMAT(dwh_capacity.date_dimension.fulldate, '%Y-%m-%d') as 'Date'

FROM dwh_capacity.internal_volume_capacity_fact
JOIN dwh_capacity.internal_volume_dimension
ON dwh_capacity.internal_volume_dimension.tk=dwh_capacity.internal_volume_capacity_fact.internalvolumetk
JOIN dwh_capacity.date_dimension
ON dwh_capacity.date_dimension.tk=dwh_capacity.internal_volume_capacity_fact.datetk

WHERE DATE_FORMAT(dwh_capacity.date_dimension.fullDate, '%Y-%m-%d') &gt;= (SELECT DATE_FORMAT(MIN(dwh_capacity.date_dimension.fullDate),'%Y-%m-%d')
FROM dwh_capacity.date_dimension)

GROUP BY dwh_capacity.internal_volume_dimension.id) begincap
HAVING begincap.BeginUsed &gt; 0 

) begin ON begin.volid=end.volid

HAVING begin.BeginUsed is not null AND DataPoints &gt; 0

) cagr

 ) cag ON cag.volid=volhistory.hvolid 



/* Get 5th Month Future Data */

UNION

SELECT 
cag.volume as 'Volume',
cag.volid as 'Volid',
null as 'AllocatedGB',
null as 'UsedGB',
DATE_ADD(volhistory.date, INTERVAL 5 MONTH) as 'Date',
cag.growthrate as 'GrowthRate',
ROUND(volhistory.AllocatedGB,2) as 'ProjectedAllocatedGB',
ROUND(((
(((((((volhistory.usedGB*cag.growthrate)+volhistory.usedGB)*cag.growthrate)+(volhistory.usedGB*cag.growthrate)+volhistory.usedGB)*cag.growthrate)+(((volhistory.usedGB*cag.growthrate)+volhistory.usedGB)*cag.growthrate)+(volhistory.usedGB*cag.growthrate)+volhistory.usedGB)*cag.growthrate)+(((((volhistory.usedGB*cag.growthrate)+volhistory.usedGB)*cag.growthrate)+(volhistory.usedGB*cag.growthrate)+volhistory.usedGB)*cag.growthrate)+(((volhistory.usedGB*cag.growthrate)+volhistory.usedGB)*cag.growthrate)+(volhistory.usedGB*cag.growthrate)+volhistory.usedGB)*cag.growthrate)+(((((((volhistory.usedGB*cag.growthrate)+volhistory.usedGB)*cag.growthrate)+(volhistory.usedGB*cag.growthrate)+volhistory.usedGB)*cag.growthrate)+(((volhistory.usedGB*cag.growthrate)+volhistory.usedGB)*cag.growthrate)+(volhistory.usedGB*cag.growthrate)+volhistory.usedGB)*cag.growthrate)+(((((volhistory.usedGB*cag.growthrate)+volhistory.usedGB)*cag.growthrate)+(volhistory.usedGB*cag.growthrate)+volhistory.usedGB)*cag.growthrate)+(((volhistory.usedGB*cag.growthrate)+volhistory.usedGB)*cag.growthrate)+(volhistory.usedGB*cag.growthrate)+volhistory.usedGB,2)
as 'ProjectedUsedGB'


FROM

(
SELECT 
dwh_capacity.internal_volume_dimension.id as 'hvolid',
dwh_capacity.internal_volume_capacity_fact.AllocatedCapacityMB/1024 as 'AllocatedGB',
dwh_capacity.internal_volume_capacity_fact.usedCapacityMB/1024 as 'UsedGB',
dwh_capacity.date_dimension.fulldate as 'Date'

FROM dwh_capacity.internal_volume_capacity_fact
JOIN dwh_capacity.internal_volume_dimension
ON dwh_capacity.internal_volume_dimension.tk=dwh_capacity.internal_volume_capacity_fact.internalvolumetk
JOIN dwh_capacity.date_dimension
ON dwh_capacity.date_dimension.tk=dwh_capacity.internal_volume_capacity_fact.datetk
AND dwh_capacity.date_dimension.latest=1
GROUP BY dwh_capacity.internal_volume_dimension.id

) volhistory

JOIN

(
SELECT
cagr.volume as 'Volume',
cagr.volid as 'Volid',
cagr.CAGR as 'GrowthRate'

FROM
(
SELECT
IFNULL(end.volume,begin.volume) as 'Volume',
IFNULL(end.volid,begin.volid) as 'Volid',
begin.BeginUsed,
begin.date as 'BeginDate',
end.EndUsed,
end.date as 'EndDate',

TIMESTAMPDIFF(MONTH,begin.date,end.date) as 'DataPoints',

ROUND(power(end.EndUsed / begin.BeginUsed, 1/TIMESTAMPDIFF(MONTH,begin.date,end.date))-1,2) as 'CAGR'

FROM
(

SELECT DISTINCT 
dwh_capacity.internal_volume_dimension.name as 'Volume',
dwh_capacity.internal_volume_dimension.id as 'volid',
(dwh_capacity.internal_volume_capacity_fact.usedCapacityMB)/1024 as 'EndUsed',
DATE_FORMAT(dwh_capacity.date_dimension.fulldate, '%Y-%m-%d') as 'Date'

FROM dwh_capacity.internal_volume_capacity_fact
JOIN dwh_capacity.internal_volume_dimension
ON dwh_capacity.internal_volume_dimension.tk=dwh_capacity.internal_volume_capacity_fact.internalvolumetk
JOIN dwh_capacity.date_dimension
ON dwh_capacity.date_dimension.tk=dwh_capacity.internal_volume_capacity_fact.datetk
AND dwh_capacity.date_dimension.latest=1
AND dwh_capacity.internal_volume_capacity_fact.usedCapacityMB&gt;0

GROUP BY dwh_capacity.internal_volume_dimension.tk

) end

LEFT JOIN

(

SELECT
begincap.Volume,
begincap.volid,
begincap.BeginUsed,
begincap.Date

FROM(
SELECT DISTINCT 
dwh_capacity.internal_volume_dimension.name as 'Volume',
dwh_capacity.internal_volume_dimension.id as 'volid',
(dwh_capacity.internal_volume_capacity_fact.usedCapacityMB)/1024 as 'BeginUsed',
DATE_FORMAT(dwh_capacity.date_dimension.fulldate, '%Y-%m-%d') as 'Date'

FROM dwh_capacity.internal_volume_capacity_fact
JOIN dwh_capacity.internal_volume_dimension
ON dwh_capacity.internal_volume_dimension.tk=dwh_capacity.internal_volume_capacity_fact.internalvolumetk
JOIN dwh_capacity.date_dimension
ON dwh_capacity.date_dimension.tk=dwh_capacity.internal_volume_capacity_fact.datetk

WHERE DATE_FORMAT(dwh_capacity.date_dimension.fullDate, '%Y-%m-%d') &gt;= (SELECT DATE_FORMAT(MIN(dwh_capacity.date_dimension.fullDate),'%Y-%m-%d')
FROM dwh_capacity.date_dimension)

GROUP BY dwh_capacity.internal_volume_dimension.id) begincap
HAVING begincap.BeginUsed &gt; 0 

) begin ON begin.volid=end.volid

HAVING begin.BeginUsed is not null AND DataPoints &gt; 0

) cagr

 ) cag ON cag.volid=volhistory.hvolid 


/* Get 6th Month Future Data */

UNION

SELECT 
cag.volume as 'Volume',
cag.volid as 'Volid',
null as 'AllocatedGB',
null as 'UsedGB',
DATE_ADD(volhistory.date, INTERVAL 6 MONTH) as 'Date',
cag.growthrate as 'GrowthRate',
ROUND(volhistory.AllocatedGB,2) as 'ProjectedAllocatedGB',
ROUND(((
(((((((((volhistory.usedGB*cag.growthrate)+volhistory.usedGB)*cag.growthrate)+(volhistory.usedGB*cag.growthrate)+volhistory.usedGB)*cag.growthrate)+(((volhistory.usedGB*cag.growthrate)+volhistory.usedGB)*cag.growthrate)+(volhistory.usedGB*cag.growthrate)+volhistory.usedGB)*cag.growthrate)+(((((volhistory.usedGB*cag.growthrate)+volhistory.usedGB)*cag.growthrate)+(volhistory.usedGB*cag.growthrate)+volhistory.usedGB)*cag.growthrate)+(((volhistory.usedGB*cag.growthrate)+volhistory.usedGB)*cag.growthrate)+(volhistory.usedGB*cag.growthrate)+volhistory.usedGB)*cag.growthrate)+(((((((volhistory.usedGB*cag.growthrate)+volhistory.usedGB)*cag.growthrate)+(volhistory.usedGB*cag.growthrate)+volhistory.usedGB)*cag.growthrate)+(((volhistory.usedGB*cag.growthrate)+volhistory.usedGB)*cag.growthrate)+(volhistory.usedGB*cag.growthrate)+volhistory.usedGB)*cag.growthrate)+(((((volhistory.usedGB*cag.growthrate)+volhistory.usedGB)*cag.growthrate)+(volhistory.usedGB*cag.growthrate)+volhistory.usedGB)*cag.growthrate)+(((volhistory.usedGB*cag.growthrate)+volhistory.usedGB)*cag.growthrate)+(volhistory.usedGB*cag.growthrate)+volhistory.usedGB)*cag.growthrate)+(((((((((volhistory.usedGB*cag.growthrate)+volhistory.usedGB)*cag.growthrate)+(volhistory.usedGB*cag.growthrate)+volhistory.usedGB)*cag.growthrate)+(((volhistory.usedGB*cag.growthrate)+volhistory.usedGB)*cag.growthrate)+(volhistory.usedGB*cag.growthrate)+volhistory.usedGB)*cag.growthrate)+(((((volhistory.usedGB*cag.growthrate)+volhistory.usedGB)*cag.growthrate)+(volhistory.usedGB*cag.growthrate)+volhistory.usedGB)*cag.growthrate)+(((volhistory.usedGB*cag.growthrate)+volhistory.usedGB)*cag.growthrate)+(volhistory.usedGB*cag.growthrate)+volhistory.usedGB)*cag.growthrate)+(((((((volhistory.usedGB*cag.growthrate)+volhistory.usedGB)*cag.growthrate)+(volhistory.usedGB*cag.growthrate)+volhistory.usedGB)*cag.growthrate)+(((volhistory.usedGB*cag.growthrate)+volhistory.usedGB)*cag.growthrate)+(volhistory.usedGB*cag.growthrate)+volhistory.usedGB)*cag.growthrate)+(((((volhistory.usedGB*cag.growthrate)+volhistory.usedGB)*cag.growthrate)+(volhistory.usedGB*cag.growthrate)+volhistory.usedGB)*cag.growthrate)+(((volhistory.usedGB*cag.growthrate)+volhistory.usedGB)*cag.growthrate)+(volhistory.usedGB*cag.growthrate)+volhistory.usedGB,2)

as 'ProjectedUsedGB'


FROM

(
SELECT 
dwh_capacity.internal_volume_dimension.id as 'hvolid',
dwh_capacity.internal_volume_capacity_fact.AllocatedCapacityMB/1024 as 'AllocatedGB',
dwh_capacity.internal_volume_capacity_fact.usedCapacityMB/1024 as 'UsedGB',
dwh_capacity.date_dimension.fulldate as 'Date'

FROM dwh_capacity.internal_volume_capacity_fact
JOIN dwh_capacity.internal_volume_dimension
ON dwh_capacity.internal_volume_dimension.tk=dwh_capacity.internal_volume_capacity_fact.internalvolumetk
JOIN dwh_capacity.date_dimension
ON dwh_capacity.date_dimension.tk=dwh_capacity.internal_volume_capacity_fact.datetk
AND dwh_capacity.date_dimension.latest=1
GROUP BY dwh_capacity.internal_volume_dimension.id

) volhistory

JOIN

(
SELECT
cagr.volume as 'Volume',
cagr.volid as 'Volid',
cagr.CAGR as 'GrowthRate'

FROM
(
SELECT
IFNULL(end.volume,begin.volume) as 'Volume',
IFNULL(end.volid,begin.volid) as 'Volid',
begin.BeginUsed,
begin.date as 'BeginDate',
end.EndUsed,
end.date as 'EndDate',

TIMESTAMPDIFF(MONTH,begin.date,end.date) as 'DataPoints',

ROUND(power(end.EndUsed / begin.BeginUsed, 1/TIMESTAMPDIFF(MONTH,begin.date,end.date))-1,2) as 'CAGR'

FROM
(

SELECT DISTINCT 
dwh_capacity.internal_volume_dimension.name as 'Volume',
dwh_capacity.internal_volume_dimension.id as 'volid',
(dwh_capacity.internal_volume_capacity_fact.usedCapacityMB)/1024 as 'EndUsed',
DATE_FORMAT(dwh_capacity.date_dimension.fulldate, '%Y-%m-%d') as 'Date'

FROM dwh_capacity.internal_volume_capacity_fact
JOIN dwh_capacity.internal_volume_dimension
ON dwh_capacity.internal_volume_dimension.tk=dwh_capacity.internal_volume_capacity_fact.internalvolumetk
JOIN dwh_capacity.date_dimension
ON dwh_capacity.date_dimension.tk=dwh_capacity.internal_volume_capacity_fact.datetk
AND dwh_capacity.date_dimension.latest=1
AND dwh_capacity.internal_volume_capacity_fact.usedCapacityMB&gt;0

GROUP BY dwh_capacity.internal_volume_dimension.tk

) end

LEFT JOIN

(

SELECT
begincap.Volume,
begincap.volid,
begincap.BeginUsed,
begincap.Date

FROM(
SELECT DISTINCT 
dwh_capacity.internal_volume_dimension.name as 'Volume',
dwh_capacity.internal_volume_dimension.id as 'volid',
(dwh_capacity.internal_volume_capacity_fact.usedCapacityMB)/1024 as 'BeginUsed',
DATE_FORMAT(dwh_capacity.date_dimension.fulldate, '%Y-%m-%d') as 'Date'

FROM dwh_capacity.internal_volume_capacity_fact
JOIN dwh_capacity.internal_volume_dimension
ON dwh_capacity.internal_volume_dimension.tk=dwh_capacity.internal_volume_capacity_fact.internalvolumetk
JOIN dwh_capacity.date_dimension
ON dwh_capacity.date_dimension.tk=dwh_capacity.internal_volume_capacity_fact.datetk

WHERE DATE_FORMAT(dwh_capacity.date_dimension.fullDate, '%Y-%m-%d') &gt;= (SELECT DATE_FORMAT(MIN(dwh_capacity.date_dimension.fullDate),'%Y-%m-%d')
FROM dwh_capacity.date_dimension)

GROUP BY dwh_capacity.internal_volume_dimension.id) begincap
HAVING begincap.BeginUsed &gt; 0 

) begin ON begin.volid=end.volid

HAVING begin.BeginUsed is not null AND DataPoints &gt; 0

) cagr

 ) cag ON cag.volid=volhistory.hvolid </sqlText>
		<mdProjectedItems><mdProjectedItem name="Volume"/><mdProjectedItem name="Volid"/><mdProjectedItem name="AllocatedGB"/><mdProjectedItem name="UsedGB"/><mdProjectedItem name="Date"/><mdProjectedItem name="GrowthRate"/><mdProjectedItem name="ProjectedAllocatedGB"/><mdProjectedItem name="ProjectedUsedGB"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Volume"><expression>[SQL3].[Volume]</expression></dataItem><dataItem name="Volid"><expression>[SQL3].[Volid]</expression></dataItem><dataItem name="AllocatedGB" aggregate="total"><expression>[SQL3].[AllocatedGB]</expression></dataItem><dataItem name="UsedGB" aggregate="total"><expression>[SQL3].[UsedGB]</expression></dataItem><dataItem name="Date"><expression>[SQL3].[Date]</expression></dataItem><dataItem name="GrowthRate"><expression>[SQL3].[GrowthRate]</expression></dataItem><dataItem name="ProjectedAllocatedGB" aggregate="total"><expression>[SQL3].[ProjectedAllocatedGB]</expression></dataItem><dataItem name="ProjectedUsedGB" aggregate="total"><expression>[SQL3].[ProjectedUsedGB]</expression></dataItem></selection>
		</query><query name="Forecast ETL">
			<source>
				
			<sqlQuery name="SQL4" dataSource="dwh_capacity" type="passThrough">
			<sqlText>
SELECT
dwh_custom.volume_forecast.Volume as 'Volume',
dwh_custom.volume_forecast.Volid as 'Volid',
dwh_custom.volume_forecast.AllocatedGB as 'AllocatedGB',
dwh_custom.volume_forecast.UsedGB as 'UsedGB',
dwh_custom.volume_forecast.Date as 'Date',
dwh_custom.volume_forecast.GrowthRate as 'GrowthRate',
dwh_custom.volume_forecast.ProjectedAllocatedGB as 'ProjectedAllocatedGB',
dwh_custom.volume_forecast.ProjectedUsedGB as 'ProjectedUsedGB'

FROM dwh_custom.volume_forecast
</sqlText>
		<mdProjectedItems><mdProjectedItem name="Volume"/><mdProjectedItem name="Volid"/><mdProjectedItem name="AllocatedGB"/><mdProjectedItem name="UsedGB"/><mdProjectedItem name="Date"/><mdProjectedItem name="GrowthRate"/><mdProjectedItem name="ProjectedAllocatedGB"/><mdProjectedItem name="ProjectedUsedGB"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Volume"><expression>[SQL4].[Volume]</expression></dataItem><dataItem name="Volid"><expression>[SQL4].[Volid]</expression></dataItem><dataItem name="AllocatedGB" aggregate="total"><expression>[SQL4].[AllocatedGB]</expression></dataItem><dataItem name="UsedGB" aggregate="total"><expression>[SQL4].[UsedGB]</expression></dataItem><dataItem name="Date"><expression>[SQL4].[Date]</expression></dataItem><dataItem name="GrowthRate" aggregate="maximum"><expression>[SQL4].[GrowthRate]</expression></dataItem><dataItem name="ProjectedAllocatedGB" aggregate="total"><expression>[SQL4].[ProjectedAllocatedGB]</expression></dataItem><dataItem name="ProjectedUsedGB" aggregate="total"><expression>[SQL4].[ProjectedUsedGB]</expression></dataItem><dataItem name="Used (TB) in 6 Months" aggregate="total"><expression>if([Max Date]=[Date]) THEN ([ProjectedUsedGB]) ELSE (0)</expression></dataItem><dataItem name="Max Date"><expression>maximum([Date] for report)</expression></dataItem></selection>
		<detailFilters><detailFilter use="optional"><filterExpression>[Volume]=?sVol?</filterExpression></detailFilter></detailFilters></query><query name="1 Month Trend">
			<source>
				
			<sqlQuery name="SQL5" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT
dwh_capacity.internal_volume_dimension.name as 'Volume',
dwh_capacity.internal_volume_dimension.id as 'Volid',
dwh_capacity.internal_volume_capacity_fact.allocatedCapacityMB/1024 as 'AllocatedGB',
dwh_capacity.internal_volume_capacity_fact.usedCapacityMB/1024 as 'UsedGB',
dwh_capacity.date_dimension.fulldate as 'Date',
null as 'GrowthRate',
null as 'ProjectedAllocatedGB',
null as 'ProjectedUsedGB'

FROM dwh_capacity.internal_volume_capacity_fact
JOIN dwh_capacity.internal_volume_dimension
ON   dwh_capacity.internal_volume_dimension.tk=dwh_capacity.internal_volume_capacity_fact.internalvolumetk

JOIN dwh_capacity.date_dimension
ON   dwh_capacity.date_dimension.tk=dwh_capacity.internal_volume_capacity_fact.datetk
AND  dwh_capacity.date_dimension.repday=1
 
WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
FROM dwh_capacity.date_dimension JOIN dwh_capacity.internal_volume_capacity_fact 
ON dwh_capacity.internal_volume_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 30 DAY



GROUP BY dwh_capacity.internal_volume_dimension.id, dwh_capacity.date_dimension.fulldate</sqlText>
		<mdProjectedItems><mdProjectedItem name="Volume"/><mdProjectedItem name="Volid"/><mdProjectedItem name="AllocatedGB"/><mdProjectedItem name="UsedGB"/><mdProjectedItem name="Date"/><mdProjectedItem name="GrowthRate"/><mdProjectedItem name="ProjectedAllocatedGB"/><mdProjectedItem name="ProjectedUsedGB"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Volume"><expression>[SQL5].[Volume]</expression></dataItem><dataItem name="Volid"><expression>[SQL5].[Volid]</expression></dataItem><dataItem name="AllocatedGB"><expression>[SQL5].[AllocatedGB]</expression></dataItem><dataItem name="UsedGB" aggregate="total"><expression>[SQL5].[UsedGB]</expression></dataItem><dataItem name="Date"><expression>[SQL5].[Date]</expression></dataItem><dataItem name="GrowthRate"><expression>[SQL5].[GrowthRate]</expression></dataItem><dataItem name="ProjectedAllocatedGB"><expression>[SQL5].[ProjectedAllocatedGB]</expression></dataItem><dataItem name="ProjectedUsedGB"><expression>[SQL5].[ProjectedUsedGB]</expression></dataItem></selection>
		<detailFilters><detailFilter use="optional"><filterExpression>[Volume]=?sVol?</filterExpression></detailFilter></detailFilters></query><query name="1 Year Trend">
			<source>
				
			<sqlQuery name="SQL6" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT
dwh_capacity.internal_volume_dimension.name as 'Volume',
dwh_capacity.internal_volume_dimension.id as 'Volid',
dwh_capacity.internal_volume_capacity_fact.allocatedCapacityMB/1024 as 'AllocatedGB',
dwh_capacity.internal_volume_capacity_fact.usedCapacityMB/1024 as 'UsedGB',
dwh_capacity.date_dimension.fulldate as 'Date',
null as 'GrowthRate',
null as 'ProjectedAllocatedGB',
null as 'ProjectedUsedGB'

FROM dwh_capacity.internal_volume_capacity_fact
JOIN dwh_capacity.internal_volume_dimension
ON   dwh_capacity.internal_volume_dimension.tk=dwh_capacity.internal_volume_capacity_fact.internalvolumetk

JOIN dwh_capacity.date_dimension
ON   dwh_capacity.date_dimension.tk=dwh_capacity.internal_volume_capacity_fact.datetk
AND  dwh_capacity.date_dimension.repmonthorlatest=1
 
WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
FROM dwh_capacity.date_dimension JOIN dwh_capacity.internal_volume_capacity_fact 
ON dwh_capacity.internal_volume_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 12 MONTH



GROUP BY dwh_capacity.internal_volume_dimension.id, dwh_capacity.date_dimension.fulldate</sqlText>
		<mdProjectedItems><mdProjectedItem name="Volume"/><mdProjectedItem name="Volid"/><mdProjectedItem name="AllocatedGB"/><mdProjectedItem name="UsedGB"/><mdProjectedItem name="Date"/><mdProjectedItem name="GrowthRate"/><mdProjectedItem name="ProjectedAllocatedGB"/><mdProjectedItem name="ProjectedUsedGB"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Volume"><expression>[SQL6].[Volume]</expression></dataItem><dataItem name="Volid"><expression>[SQL6].[Volid]</expression></dataItem><dataItem name="AllocatedGB"><expression>[SQL6].[AllocatedGB]</expression></dataItem><dataItem name="UsedGB" aggregate="total"><expression>[SQL6].[UsedGB]</expression></dataItem><dataItem name="Date"><expression>[SQL6].[Date]</expression></dataItem><dataItem name="GrowthRate"><expression>[SQL6].[GrowthRate]</expression></dataItem><dataItem name="ProjectedAllocatedGB"><expression>[SQL6].[ProjectedAllocatedGB]</expression></dataItem><dataItem name="ProjectedUsedGB"><expression>[SQL6].[ProjectedUsedGB]</expression></dataItem></selection>
		<detailFilters><detailFilter use="optional"><filterExpression>[Volume]=?sVol?</filterExpression></detailFilter></detailFilters></query><query name="3 Year Trend">
			<source>
				
			<sqlQuery name="SQL7" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT
dwh_capacity.internal_volume_dimension.name as 'Volume',
dwh_capacity.internal_volume_dimension.id as 'Volid',
dwh_capacity.internal_volume_capacity_fact.allocatedCapacityMB/1024 as 'AllocatedGB',
dwh_capacity.internal_volume_capacity_fact.usedCapacityMB/1024 as 'UsedGB',
dwh_capacity.date_dimension.fulldate as 'Date',
null as 'GrowthRate',
null as 'ProjectedAllocatedGB',
null as 'ProjectedUsedGB'

FROM dwh_capacity.internal_volume_capacity_fact
JOIN dwh_capacity.internal_volume_dimension
ON   dwh_capacity.internal_volume_dimension.tk=dwh_capacity.internal_volume_capacity_fact.internalvolumetk

JOIN dwh_capacity.date_dimension
ON   dwh_capacity.date_dimension.tk=dwh_capacity.internal_volume_capacity_fact.datetk
AND  dwh_capacity.date_dimension.repmonthorlatest=1
 
WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
FROM dwh_capacity.date_dimension JOIN dwh_capacity.internal_volume_capacity_fact 
ON dwh_capacity.internal_volume_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 3 YEAR



GROUP BY dwh_capacity.internal_volume_dimension.id, dwh_capacity.date_dimension.fulldate</sqlText>
		<mdProjectedItems><mdProjectedItem name="Volume"/><mdProjectedItem name="Volid"/><mdProjectedItem name="AllocatedGB"/><mdProjectedItem name="UsedGB"/><mdProjectedItem name="Date"/><mdProjectedItem name="GrowthRate"/><mdProjectedItem name="ProjectedAllocatedGB"/><mdProjectedItem name="ProjectedUsedGB"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Volume"><expression>[SQL7].[Volume]</expression></dataItem><dataItem name="Volid"><expression>[SQL7].[Volid]</expression></dataItem><dataItem name="AllocatedGB"><expression>[SQL7].[AllocatedGB]</expression></dataItem><dataItem name="UsedGB" aggregate="total"><expression>[SQL7].[UsedGB]</expression></dataItem><dataItem name="Date"><expression>[SQL7].[Date]</expression></dataItem><dataItem name="GrowthRate"><expression>[SQL7].[GrowthRate]</expression></dataItem><dataItem name="ProjectedAllocatedGB"><expression>[SQL7].[ProjectedAllocatedGB]</expression></dataItem><dataItem name="ProjectedUsedGB"><expression>[SQL7].[ProjectedUsedGB]</expression></dataItem></selection>
		<detailFilters><detailFilter use="optional"><filterExpression>[Volume]=?sVol?</filterExpression></detailFilter></detailFilters></query><query name="Volume Prompt">
			<source>
				
			<sqlQuery name="SQL8" dataSource="dwh_inventory" type="passThrough">
			<sqlText>SELECT
dwh_inventory.internal_volume.name as 'Volume'

FROM dwh_inventory.internal_volume

ORDER BY dwh_inventory.internal_volume.name</sqlText>
		<mdProjectedItems><mdProjectedItem name="Volume"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Volume"><expression>[SQL8].[Volume]</expression></dataItem></selection>
		</query></queries></report>